07. Understanding the database
SOLUTION:
- rental_id
- inventory_id
- rental_date
- customer_id
- return_date
- staff_id
QUIZ QUESTION::
How many foreign keys exist in each of the following tables?
ANSWER CHOICES:
|
Table |
Number of Foreign Keys |
|---|---|
2 |
|
3 |
|
3 |
|
4 |
|
2 |
|
1 |
|
0 |
|
0 |
|
3 |
SOLUTION:
|
Table |
Number of Foreign Keys |
|---|---|
|
2 |
|
|
3 |
|
|
3 |
|
|
3 |
|
|
3 |
|
|
2 |
|
|
1 |
|
|
0 |
|
|
0 |
|
|
0 |
|
|
0 |
|
|
3 |
|
|
3 |